Tabela OrderItem

Definicja tabeli OrderItem

Name

OrderItem

Code

OrderItem

Comment

 


Lista kolumn tabeli OrderItem

Name

Code

OrderID

OrderID

PriorityID

PriorityID

OrderTypeID

OrderTypeID

PaymentTypeID

PaymentTypeID

FrequencyID

FrequencyID

EventID

EventID

ReferralID

ReferralID

EpisodeID

EpisodeID

Eve_EventID

Eve_EventID

PersonID

PersonID

CollectionPerfServID

CollectionPerfServID

OrderDT

OrderDT

PerfOrgUnit

PerfOrgUnit

ExternalPerfOrgUnit

ExternalPerfOrgUnit

OrderingOrgUnit

OrderingOrgUnit

OrderingPerson

OrderingPerson

InsertPerson

InsertPerson

SuggestedPerfDT

SuggestedPerfDT

SuggestedStopDT

SuggestedStopDT

Internal

Internal

Comments

Comments

Reason

Reason

OrderingExternalOrgUnit

OrderingExternalOrgUnit

OrderingExternalDoctor

OrderingExternalDoctor

OrderPurposeID

OrderPurposeID

AdvanceAmount

AdvanceAmount

AdvanceAmountDT

AdvanceAmountDT

ExpireDT

ExpireDT

EnteringOrgUnitID

EnteringOrgUnitID

BloodGroup

BloodGroup


Kolumna OrderID tabeli OrderItem

Definicja kolumny OrderID tabeli OrderItem

Name

OrderID

Code

OrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PriorityID tabeli OrderItem

Definicja kolumny PriorityID tabeli OrderItem

Name

PriorityID

Code

PriorityID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrderTypeID tabeli OrderItem

Definicja kolumny OrderTypeID tabeli OrderItem

Name

OrderTypeID

Code

OrderTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentTypeID tabeli OrderItem

Definicja kolumny PaymentTypeID tabeli OrderItem

Name

PaymentTypeID

Code

PaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FrequencyID tabeli OrderItem

Definicja kolumny FrequencyID tabeli OrderItem

Name

FrequencyID

Code

FrequencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli OrderItem

Definicja kolumny EventID tabeli OrderItem

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReferralID tabeli OrderItem

Definicja kolumny ReferralID tabeli OrderItem

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli OrderItem

Definicja kolumny EpisodeID tabeli OrderItem

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Eve_EventID tabeli OrderItem

Definicja kolumny Eve_EventID tabeli OrderItem

Name

Eve_EventID

Code

Eve_EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli OrderItem

Definicja kolumny PersonID tabeli OrderItem

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CollectionPerfServID tabeli OrderItem

Definicja kolumny CollectionPerfServID tabeli OrderItem

Name

CollectionPerfServID

Code

CollectionPerfServID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID uslugi pobrania materialu


Kolumna OrderDT tabeli OrderItem

Definicja kolumny OrderDT tabeli OrderItem

Name

OrderDT

Code

OrderDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PerfOrgUnit tabeli OrderItem

Definicja kolumny PerfOrgUnit tabeli OrderItem

Name

PerfOrgUnit

Code

PerfOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalPerfOrgUnit tabeli OrderItem

Definicja kolumny ExternalPerfOrgUnit tabeli OrderItem

Name

ExternalPerfOrgUnit

Code

ExternalPerfOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingOrgUnit tabeli OrderItem

Definicja kolumny OrderingOrgUnit tabeli OrderItem

Name

OrderingOrgUnit

Code

OrderingOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingPerson tabeli OrderItem

Definicja kolumny OrderingPerson tabeli OrderItem

Name

OrderingPerson

Code

OrderingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertPerson tabeli OrderItem

Definicja kolumny InsertPerson tabeli OrderItem

Name

InsertPerson

Code

InsertPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SuggestedPerfDT tabeli OrderItem

Definicja kolumny SuggestedPerfDT tabeli OrderItem

Name

SuggestedPerfDT

Code

SuggestedPerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SuggestedStopDT tabeli OrderItem

Definicja kolumny SuggestedStopDT tabeli OrderItem

Name

SuggestedStopDT

Code

SuggestedStopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Internal tabeli OrderItem

Definicja kolumny Internal tabeli OrderItem

Name

Internal

Code

Internal

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Comments tabeli OrderItem

Definicja kolumny Comments tabeli OrderItem

Name

Comments

Code

Comments

Data Type

VARCHAR2(1020)

Mandatory

No

Comment

 


Kolumna Reason tabeli OrderItem

Definicja kolumny Reason tabeli OrderItem

Name

Reason

Code

Reason

Data Type

VARCHAR2(268)

Mandatory

No

Comment

 


Kolumna OrderingExternalOrgUnit tabeli OrderItem

Definicja kolumny OrderingExternalOrgUnit tabeli OrderItem

Name

OrderingExternalOrgUnit

Code

OrderingExternalOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingExternalDoctor tabeli OrderItem

Definicja kolumny OrderingExternalDoctor tabeli OrderItem

Name

OrderingExternalDoctor

Code

OrderingExternalDoctor

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderPurposeID tabeli OrderItem

Definicja kolumny OrderPurposeID tabeli OrderItem

Name

OrderPurposeID

Code

OrderPurposeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdvanceAmount tabeli OrderItem

Definicja kolumny AdvanceAmount tabeli OrderItem

Name

AdvanceAmount

Code

AdvanceAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

Kwota zaliczki wymaganej przed przyjeciem pacjenta do szpitala na podstawie danego zamówienia na hospitalizacje / kwota zaliczki wplaconej na danej fakturrze zaliczkowej (faktura zaliczkowa <==>DocumentTypeID = 3)


Kolumna AdvanceAmountDT tabeli OrderItem

Definicja kolumny AdvanceAmountDT tabeli OrderItem

Name

AdvanceAmountDT

Code

AdvanceAmountDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExpireDT tabeli OrderItem

Definicja kolumny ExpireDT tabeli OrderItem

Name

ExpireDT

Code

ExpireDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna EnteringOrgUnitID tabeli OrderItem

Definicja kolumny EnteringOrgUnitID tabeli OrderItem

Name

EnteringOrgUnitID

Code

EnteringOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BloodGroup tabeli OrderItem

Definicja kolumny BloodGroup tabeli OrderItem

Name

BloodGroup

Code

BloodGroup

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Sluzy do przechowywania grupy krwi pacjenta na czas utworzenia zamówienia


Lista kluczy tabeli OrderItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OrderItem

Definicja klucza Identifier_1 tabeli OrderItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment